﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SMP.Resource
{
    using System.Data;

    public class Thongke_Res : BaseDB
    {
        public DataTable Get_Thongke_Hangban_Theongay(DateTime dt_Ngaybd, DateTime dt_Ngaykt)
        {
            string sql = string.Format(@"SET DATEFORMAT dmy; EXEC Get_Thongke_Hangban_Theongay '{0}', '{1}' ", dt_Ngaybd, dt_Ngaykt);
            return ExecuteQuery(sql);
        }

        public DataTable Get_Thongke_Hangnhap_Theongay(DateTime dt_Ngaybd, DateTime dt_Ngaykt)
        {
            string sql = string.Format(@"SET DATEFORMAT dmy; EXEC Get_Thongke_Hangnhap_Theongay '{0}', '{1}' ", dt_Ngaybd, dt_Ngaykt);
            return ExecuteQuery(sql);
        }


    }
}
